Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_2043

R_2043

DisclosePersonType

DocumentHandsOut

DisclosePersonTypeID

 

 

R_2044

R_2044

Person

DocumentHandsOut

PersonID

 

 

R_8230

R_8230

ResultsHandOutFormat

ResultsHandOutFormatText

ResultsHandOutFormatID

 

 

R_8231

R_8231

ResultsHandOutFormat

ResultsHandOut

ResultsHandOutFormatID

 

 

R_8390

R_8390

DescriptivePhrase

LDescriptivePhraseAssignment

 

 

 

R_8391

R_8391

DescriptiveDataType

LDescriptivePhraseAssignment

DescriptiveDataTypeID

 

 

R_8392

R_8392

UserDefinition

LDescriptivePhraseAssignment

PersonID

 

 

R_8394

R_8394

UserType

LDescriptivePhraseAssignment

UserTypeID

 

 

R_8395

R_8395

Service

LDescriptivePhraseAssignment

ServID

 

 

R_8810

R_8810

Event

Tiss

EventID

 

 

R_8811

R_8811

DescriptiveData

Tiss

DescriptiveDataID

 

 

R_8812

R_8812

PerfContractService

Tiss

ContractServicePerfID

 

 

R_8813

R_8813

UserDefinition

Tiss

InsertingPerson

 

 

R_8814

R_8814

UserDefinition

Tiss

LastModifiedPerson

 

 

R_9011

R_9011

Event

LSysFctDescriptiveData

EventID

 

 

R_9012

R_9012

DescriptiveData

LSysFctDescriptiveData

DescriptiveDataID

 

 

R_9013

R_9013

Episode

LSysFctDescriptiveData

EpisodeID

 

 

R_9014

R_9014

SysFct

LSysFctDescriptiveData

SysFctID

 

 

R_9213

R_9213

IdentifierType

DescriptiveDataType

IdentifierTypeID

 

 

R_9259

R_9259

ServiceType

LServiceTypeDescriptivePhrase

ServiceTypeID

 

 

R_9260

R_9260

DescriptivePhrase

LServiceTypeDescriptivePhrase

DescriptivePhraseID

 

 

R_9414

R_9414

Contract

PerfContractService

ContractID

 

 

R_10167

R_10167

ICD

Episode

NextHospitalizationICDID

 

 

R_10168

R_10168

DictionaryValue

Episode

SuggestedSanatoriumID

 

 

R_10345

R_10345

PerfContractService

LTissStatisticalPCS

ContractServicePerfID

 

 

R_10346

R_10346

Tiss

LTissStatisticalPCS

TissID

 

 

R_10364

R_10364

ConsultationStatus

ConsultationStatusText

ConsultationStatusID

 

 

R_10365

R_10365

PerfService

Consultation

PerfServiceID

 

 

R_10366

R_10366

ConsultationStatus

Consultation

ConsultationStatusID

 

 


1  2